<?
include_once "accesscontrol.php";
require_once("../conn.php");

$c_name = $_GET['cname'];
$ename  = $_GET['name'];

$q1 = "SELECT * FROM job_post WHERE Company= '$c_name' AND ename = '$ename'";
$r1 = mysql_query($q1) or die(mysql_error());


$q2 = "SELECT * FROM job_employer_info WHERE CompanyName= '$c_name' AND ename = '$ename'";
$r2 = mysql_query($q2) or die(mysql_error());
$a2 = mysql_fetch_array($r2);



?>

<br>
<br>	

<table align=center border=1 bordercolor=993300 cellspacing=0 width=460>
	<tr>
		<td>
			<table border=0 width=500 cellspacing=0 cellpadding=4>	
				<br><br>			
				<tr>
					<td>
						<table border=0 width=450 align=center>
							<tr>
								<td>
							<font size=5><?=$a2[CompanyName]?></font><br><br>
							<?=$a2[CompanyProfile]?><br><br><br><br>
								</td>
							</tr>
						</table>
					</td>
				</tr>	
				<tr>
					<td width=500 bgcolor=#736F6E align=center>
						<font color=white size=3><b>Jobs Posted By Company</b></font>
					</td>
				</tr>
<?
while($as = mysql_fetch_array($r1))
{
$time = strtotime($as['createdTime']);
$dateAdd = date("d M Y" ,$time);
?>
<table border=0 width=500 cellspacing=0 cellpadding=4>	
<?
if($col == "cococo")
	    { 
	     $col = "dddddd"; 
	    }
	         	 else
		{ 
		$col = "cococo"; 
		} 
?>
<tr bgcolor=<?=$col?>>
		<td width=90>
			<?=$dateAdd?><br><br><br>
		</td>
		<td width=400>
			<a class=BlackLink href="JobInfo.php?job_id=<?=$as[job_id]?>"><font size=3 color=blue><?=$as[position]?></font></a>  ~  <font size=3> <?=$as[Company]?> </font><br>
			<?=$as[CompanyState]?><br>
			<?=$as[short_desc]?>
		</td>
	</tr>
</table>
<?
}
?>			
			</table>
		</td>
	</tr>
</table>



<? include_once('../footer.php'); ?>
					